Change the Default Output on a Power BI KPI Visual
Updated: 2023-04-27 05:00:00
In this article, we look at how to enhance and change the output for a Power BI KPI visual in this step-by-step example.- In this article, we look at how to enhance and change the output for a Power BI KPI visual in this step-by-step example.
Learn about SQL NULL values and how SQL Server handles NULL in Queries
Updated: 2023-04-26 05:00:00
Learn about NULL values and how SQL Server handles NULL values when querying data from tables and how some functions handle NULL values.How Snowflake Creates and Detects Deadlocks
Updated: 2023-04-26 05:00:00
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.PostgreSQL Basics: Getting started with psql
Updated: 2023-04-24 18:16:16PostgreSQL has a separate command-line tool that’s been available for decades and is included with any installation of PostgreSQL. Many long-term PostgreSQL users, developers, and administrators rely on psql to help them quickly connect to databases, examine the schema, and execute SQL queries. Knowing how to install and use basic psql commands is an essential … The post PostgreSQL Basics: Getting started with psql appeared first on Simple Talk.Searching between two date values in SQL Server
Updated: 2023-04-24 05:00:00
Learn different ways to select data between two dates using various techniques along with how to improve performance for very large tables.Star Schema vs Snowflake Schema Considerations
Updated: 2023-04-24 05:00:00
Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema?Cache SQL Server Data in a .NET Web Application
Updated: 2023-04-21 05:00:00
One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.One use case for NOT using schema prefixes
Updated: 2023-04-20 15:59:28I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and … The post One use case for NOT using schema prefixes appeared first on Simple Talk.Aggregate and Summarize Totals with SQL SUM
Updated: 2023-04-20 05:00:00
In this article, we look at different examples of using SUM when aggregating and summarizing totals when working with SQL Server data.Mount Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL and Azure Cosmos DB to Azure Databricks
Updated: 2023-04-20 05:00:00
In this article, we will walk through how to mount different types of Azure storage like Azure Blob Storage, Azure Data Lake Gen 2, Azure SQL, and Azure Cosmos DB, to Azure Databricks for data-related projects.REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
Updated: 2023-04-19 05:00:00
Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.How to Conduct Linear Correlation Analysis with Python
Updated: 2023-04-19 05:00:00
In this article, we look at how to perform linear correlation analysis using Python code along with several code examples.Google Cloud Resource Management and Monitoring - Part 3
Updated: 2023-04-18 05:00:00
This article continues the GCP series and we will learn how to manage and monitor Google Cloud resources and billing.SQL Server 2022 Create Statistics AUTO_DROP Feature
Updated: 2023-04-17 05:00:00
Learn about the new AUTO_DROP setting when creating statistics in SQL Server 2022.Add Azure SQL databases to existing auto-failover group
Updated: 2023-04-17 05:00:00
In this article, we walk through the steps of how to add an Azure SQL Database to an existing auto-failover group.Understanding how to Successfully Sell the Cloud
Updated: 2023-04-14 04:46:13
Many businesses are hesitant to adopt cloud technology due to security, cost, and complexity concerns. This can make it challenging for organizations to sell the benefits, leading to missed opportunities. Learn about different techniques to help sell cloud technology in your organization.
Tips for Successful Video Interviews for Technology Professionals
Updated: 2023-04-13 05:00:00
Check out these tips and tricks for a successful video interview so the next time you have an online interview you are better prepared.How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
Updated: 2023-04-12 17:42:40
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered in 2006 with CSRF vulnerabilities. Attackers could change login credentials, change the shipping address and send DVDs to a newly set address. YouTube suffered from CSRF attacks where an attacker could perform actions of any user ING Direct …
The post How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks appeared first on Simple Talk.
How to Slice Data by Week in a Calendar Table using DAX
Updated: 2023-04-12 05:00:00
In this article, we look at how to build a time slicer by week using DAX for tables that store date data types.How to use the Timeline Slicer in Power BI Desktop
Updated: 2023-04-12 05:00:00
Learn how to add a timeline slicer to Power BI and use this visualization to add time slice capabilities to your Power BI charts.Return TOP (N) Rows using APPLY or ROW_NUMBER() in SQL Server
Updated: 2023-04-11 04:55:20
In this article, we will compare APPLY to ROW_NUMBER() for returning the TOP (n) rows from a SQL Server table.Creating a Windows Installer for a Python Application
Updated: 2023-04-11 04:55:19
The article describes the steps to create an MSI installer for a Python application for easy distribution.PostgreSQL Schema: Learning PostgreSQL with Grant
Updated: 2023-04-10 18:18:50An important aspect of building and managing a database is organizing the objects within your database. You may have tables that support different functions, for example, a schema for warehousing operations and another for sales. Some logins may need access to some tables, but not others. You might want to isolate one set of objects … The post PostgreSQL Schema: Learning PostgreSQL with Grant appeared first on Simple Talk.List Azure Functions based on Configuration Values
Updated: 2023-04-10 17:00:39A company’s Azure environment can easily grow to a level that managing all the objects may become harder. The solution of this problem requires methods to query resources, such as Azure Functions, based on their properties. One of the fetures used for this is the Azure Resource Graph . However, Function Apps configuration is beyond … The post List Azure Functions based on Configuration Values appeared first on Simple Talk.A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers
Updated: 2023-04-10 15:52:06In the first part of this series, we spoke about MySQL Replication, the different types, replication formats, benefits, and downsides, as well as a brief introduction to the requirements needed for setting up MySQL Replication. To ensure we stay on track with our intended topic, it’s important to have certain prerequisites in place before we … The post A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers appeared first on Simple Talk.Bring WSFC Cluster Online and Perform Always On Availability Group Failover to Disaster Recovery Site
Updated: 2023-04-10 05:00:00
Learn how to failover to an Always On Availability Group replica in a DR site when the primary SQL Server cluster becomes completely unavailable.Learn how to use SQL ORDER BY in Your Queries
Updated: 2023-04-10 05:00:00
In this article, we will look at different ways you can use SQL code to sort and order data along with several examples.Ordered Columnstore Indexes in SQL Server 2022
Updated: 2023-04-07 13:26:34One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is … The post Ordered Columnstore Indexes in SQL Server 2022 appeared first on Simple Talk.SQL Server 2022 Pause and Resume Creation of Table Constraints
Updated: 2023-04-07 05:00:00
In this article, learn about the new feature in SQL Server 2022 that allows you to pause and resume the creation of constraints on tables.Microsoft SQL Certifications Program Changes
Updated: 2023-04-06 05:00:00
Microsoft made changes to its certification program and knowing about these changes can help you plan for future certifications related to SQL Server or other Microsoft technologies.Using Transactions in Snowflake Stored Procedures
Updated: 2023-04-06 05:00:00
Learn about using transactions in stored procedures when working with Snowflake with these code examples and explanations.Setup a Workbench Database, Migrate Objects from Production and Modify the Workbench Database
Updated: 2023-04-05 05:00:00
Learn about setting up a workbench database, migrating objects from a production database to the workbench, and how to make changes in the workbench database.Cheat Sheet for SQL Server DBA Daily Operations
Updated: 2023-04-05 05:00:00
This article contains various code fragments and scripts that could be used to manage and check on SQL Server and databases.What is a Snowflake Schema and how to use in Power BI
Updated: 2023-04-04 05:00:00
In this article, we look at what a snowflake schema is and also how to use a snowflake schema in Power BI.Jenkins Installation, Configuration and Automation for DevOps Projects
Updated: 2023-04-04 05:00:00
Learn about a scheduling tool called Jenkins that can be used to automate the execution of PowerShell scripts and other DevOps tasks in your environment.Modifying MySQL data from within Python
Updated: 2023-04-03 23:38:55In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to … The post Modifying MySQL data from within Python appeared first on Simple Talk.Data Processing using Apache Spark and SQL Server using pymssql
Updated: 2023-04-03 05:00:00
Microsoft and Databricks have created a high-speed Apache Spark connector to read or write dataframes to SQL Server. This article covers this and a library called pymssql that can control database interactions to SQL Server.